Release 10.1A: OpenEdge Development:
Basic Database Tools

Dump as CREATE TABLE Statements option

Choose PRO/SQL Dump as CREATE TABLE and CREATE INDEX statements to generate an SQL DDL program that contains CREATE TABLE statements equivalent to those originally used to define the selected table.

Note: This option also works with non-OpenEdge databases.

When you choose this option, the Data Dictionary alphabetically lists all the tables defined for your database. Select the table for which you want to make CREATE TABLE statements. A dialog box similar to the one shown in Figure 11–15 appears.

Figure 11–15: Dump CREATE TABLE dialog box

The Dump CREATE TABLE dialog box contains the following fields:

Output File for CREATE TABLE

Specifies the filename to which you want to write the CREATE TABLE statements. The default filename for a single table is the table-name.p or database-name.p if you specified all tables.

Output File for CREATE INDEX

Specifies the filename to which you want to write the CREATE INDEX statements. The default filename for a single table is the table-name.i or database-name.i if you specified all tables. If you do not specify a filename, the Data Dictionary writes the CREATE INDEX statements to the CREATE TABLE output file.

SQL-Flavor

Specifies the type of SQL you want to use.

Create Progress Recid Field

Select this option if your database currently contains the PROGRESS_RECID field. Selecting this option will maintain the use of PROGRESS_RECID in any new tables added by this utility.

Create Shadow Columns

If your Dataserver is configured with a case sensitive code page, this box is available for selection. Selecting it provides case insensitivity compatible with the behavior of an OpenEdge database.

Include Defaults

Check if you want the OpenEdge initial value used as the default in the SQL script.

For Field Widths Use Width

Select if your OpenEdge database contains data that is larger than the display format. Change the width to the proper size. The utility will use the Width field instead of the display format.

For Field Widths Use 4GL Format

Select if you want the Data Dictionary to use the display format instead of the field’s width.

Expand x(8) to 30

If selected, indicates that fields with FORMAT set to x(8) will be given a default width of 30 characters.

After generating the file, the Data Dictionary prompts you to continue.